CREATE TRIGGER TRG_MakeDirs
ON OrderEntry
FOR INSERT
AS

DECLARE @jobnum varchar (30)
DECLARE @quotenum varchar (30)
DECLARE @type varchar (30)
DECLARE @command varchar (50)
DECLARE @command2 varchar (50)



SELECT @jobnum = (SELECT JobNumber FROM Inserted)
SELECT @quotenum = (SELECT QuoteNumber FROM Inserted)
SELECT @type = (SELECT ProjectTypeCode FROM Inserted)
SELECT @command = ('c:\newdirs.bat ' + @jobnum + ' ' + @quotenum)
SELECT @command2 = ('c:\copyfile.bat ' + @jobnum + ' ' + @type )

EXEC master..xp_cmdshell @command
EXEC master..xp_cmdshell @command2
